How to: Select multiple worksheets in a workbook.
Solution:
Press and hold down SHIFT or CTRL while choosing the tabs.
1) To select multiple contiguous worksheets:
a) Click the tab for the first sheet to be selected.
b) Press and hold down SHIFT while choosing the tab for the last sheet.
2) To select non-contiguous worksheets:
a) Click the tab for the first sheet.
b) Press and hold down CTRL while choosing each of the tabs for the desired sheets.
